Search results 17

Card image cap
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Card image cap
ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Card image cap
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Card image cap
ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image cap
LXFormat

Formats a number found at end of string to have additional leading zeros to ...

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image cap
SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

Card image cap
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Card image cap
Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...